Release 10.1A: OpenEdge Data Management:
SQL Reference

Expressions syntax in BNF

Expression (expr)

Syntax

expr ::= [ { table_name.| alias.}] column_name | character_literal | numeric_literal | date-time_literal | aggregate_function | scalar_function | numeric_arith_expr | date_arith_expr | conditional_expr | (expr)

Numeric arithmetic expression

Syntax

numeric_arith_expr ::= [ + | - ] { numeric_literal | numeric_expr } [ { + | - | * | / } numeric_arith_expr ]

Date arithmetic expression

Syntax

date_arith_expr ::= date_time_expr { + | - } int_expr | date_time_expr - date_time_expr